Adv pricing in IC
In normal IR/ISO process the price is derived from cost (+ charges)
But We want to put some mark value to the cost. I know its possible & have worked in a project before but I dont remember all the setups
Can any one help me with all the required steups, please
item cost from istore
Hi
How to find cost of item when ordered from istore with above approach. We are using below string for attribute mapping and linking for ASO application. But its not working. Any clue?
Nvl(cst_cost_api.get_item_cost(1, ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC.INVENTORY_ITEM_ID, ASO_QUOTE_PUB.G_MISS_Shipment_REC.SHIP_FROM_ORG_ID,NULL,NULL),0)
Thanks,
Sarang
I hope below 'll help you
1.
I hope below 'll help you
1. Profiles:
INV:Advanced Pricing for Intercompany Invoice Yes
QP: Source System Code Oracle Inventory
QP: Pricing Transaction Entity Intercompany
INV:Intercompany Invoice for Internal Orders Yes
CST: Transfer Pricing Option Yes, Price as incoming cost
2. Verify Context & Attribute mapping
Navigation to Oracle Pricing Manager -> Setup -> Attribute Management -> Context and Attributes
Slect the context type - pricing context & code cost
Attribute : Item cost
Select the value set
3. Set Up attribute mapping
Select Pricing Transaction Entity as Intercompany Transaction and Context Type as Pricing Context.
Navigate to the Link Attribute of COST”
Select application Inventory
use bleow in Line
User Source Type: PL/SQL API
User Value String:
cst_cost_api.get_item_cost(1,INV_IC_ORDER_PUB.G_LINE.INVENTORY_ITEM_ID, OE_ORDER_PUB.G_LINE.SHIP_FROM_ORG_ID,NULL,NULL)
Now run 'Build Attribute Mapping Rule'
4. Setup a dynamic formula
Name : Mark Up Prices
Formula : Greatest (1,(2*3))
Step1: Numeric Constant = 0
Step1: Numeric Constant = 2
Step2: Pricing Attribute , Cost Context, Item Cost
Run Build Formula Package
5. Set up a price list with the above formula
Product Context: Item
Product Attribute: All Items
Product Value: ALL
UOM: EA
Line Type: Price List Line
Application Method: Unit Price
Dynamic Formula: Mark Up Prices
6. Now assign this price list to the internal coustmer
item cost aso
Hi
How to find cost of item when ordered from istore with above approach. We are using below string for attribute mapping and linking for ASO application. But its not working. Any clue?
Nvl(cst_cost_api.get_item_cost(1, ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC.INVENTORY_ITEM_ID, ASO_QUOTE_PUB.G_MISS_Shipment_REC.SHIP_FROM_ORG_ID,NULL,NULL),0)
Thanks,
Sarang